/*
 Navicat Premium Data Transfer

 Source Server         : mysql
 Source Server Type    : MySQL
 Source Server Version : 50711
 Source Host           : localhost
 Source Database       : fast

 Target Server Type    : MySQL
 Target Server Version : 50711
 File Encoding         : utf-8

 Date: 04/17/2016 17:24:20 PM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `fast_base_company`
-- ----------------------------
DROP TABLE IF EXISTS `fast_base_company`;
CREATE TABLE `fast_base_company` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '公司主键',
  `pid` bigint(20) DEFAULT NULL COMMENT '父级主键',
  `category` varchar(50) DEFAULT '公司' COMMENT '分类（集团、公司、分公司，子公司）',
  `code` varchar(50) DEFAULT NULL COMMENT '公司编码',
  `fullName` varchar(50) DEFAULT NULL COMMENT '公司名称',
  `shortName` varchar(50) DEFAULT NULL COMMENT '公司简称',
  `nature` varchar(50) DEFAULT NULL COMMENT '公司性质（国家机关，建筑业，金融业...）',
  `manager` varchar(50) DEFAULT NULL COMMENT '法定代表人',
  `contact` varchar(50) DEFAULT NULL COMMENT '联系人',
  `phone` varchar(50) DEFAULT NULL COMMENT '联系电话',
  `fax` varchar(50) DEFAULT NULL COMMENT '	传真',
  `email` varchar(50) DEFAULT NULL COMMENT '电子邮件',
  `provinceId` varchar(50) DEFAULT NULL COMMENT '省主键',
  `province` varchar(50) DEFAULT NULL COMMENT '省',
  `cityId` varchar(50) DEFAULT NULL COMMENT '市主键',
  `city` varchar(50) DEFAULT NULL COMMENT '市',
  `countyId` varchar(50) DEFAULT NULL COMMENT '县/区主键',
  `county` varchar(50) DEFAULT NULL COMMENT '县/区',
  `address` varchar(50) DEFAULT NULL COMMENT '详细地址',
  `accountInfo` varchar(50) DEFAULT NULL COMMENT '开户信息',
  `postalcode` varchar(50) DEFAULT NULL COMMENT '邮编',
  `web` varchar(50) DEFAULT NULL COMMENT '网址',
  `description` longtext COMMENT '描述',
  `remark` longtext COMMENT '备注',
  `sortCode` int(10) DEFAULT '1' COMMENT '排序码',
  `createTime` datetime DEFAULT NULL COMMENT '创建时间',
  `createUserId` bigint(20) DEFAULT NULL COMMENT '创建用户主键',
  `createUserName` varchar(50) DEFAULT NULL COMMENT '创建用户',
  `modifyTime` datetime DEFAULT NULL COMMENT '修改时间',
  `modifyUserId` bigint(20) DEFAULT NULL COMMENT '修改用户主键',
  `modifyUserName` varchar(50) DEFAULT NULL COMMENT '修改用户',
  PRIMARY KEY (`id`),
  KEY `company_children_fk` (`pid`),
  CONSTRAINT `company_children_fk` FOREIGN KEY (`pid`) REFERENCES `fast_base_company` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='公司管理表';

-- ----------------------------
--  Records of `fast_base_company`
-- ----------------------------
BEGIN;
INSERT INTO `fast_base_company` VALUES ('4', null, '公司', '0001', '上海力软有限公司', '力软', '国家机关', '佘赐雄', '', '', '', '', null, '', null, '', null, '', '', '', '', '', '', '', null, null, null, null, null, null, null), ('5', null, '分公司', '0002', '福建力软有限公司', 'learun.fujian', '建筑业', '努尔哈赤', '', '刘德华', '', '', null, '', null, '', null, '', '', '', '', '', '', '', '1', null, null, null, null, null, null);
COMMIT;

-- ----------------------------
--  Table structure for `fast_base_dept`
-- ----------------------------
DROP TABLE IF EXISTS `fast_base_dept`;
CREATE TABLE `fast_base_dept` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '部门主键',
  `pid` bigint(20) DEFAULT NULL COMMENT '父级主键',
  `companyId` bigint(20) DEFAULT NULL COMMENT '公司主键',
  `code` varchar(50) DEFAULT NULL COMMENT '编码（唯一编码）',
  `fullName` varchar(200) DEFAULT NULL COMMENT '名称',
  `shortName` varchar(200) DEFAULT NULL COMMENT '简称',
  `nature` varchar(200) DEFAULT NULL COMMENT '性质（IT，综合性，咨询性）',
  `managerId` varchar(200) DEFAULT NULL COMMENT '负责人主键',
  `manager` varchar(200) DEFAULT NULL COMMENT '负责人',
  `phone` varchar(50) DEFAULT NULL COMMENT '联系电话',
  `fax` varchar(50) DEFAULT NULL COMMENT '	传真',
  `email` varchar(50) DEFAULT NULL COMMENT '电子邮件',
  `remark` varchar(200) DEFAULT NULL COMMENT '备注',
  `sortCode` int(10) DEFAULT '1' COMMENT '排序码',
  `createTime` datetime DEFAULT NULL COMMENT '创建时间',
  `createUserId` bigint(20) DEFAULT NULL COMMENT '创建用户主键',
  `createUserName` varchar(50) DEFAULT NULL COMMENT '创建用户',
  `modifyTime` datetime DEFAULT NULL COMMENT '修改时间',
  `modifyUserId` bigint(20) DEFAULT NULL COMMENT '修改用户主键',
  `modifyUserName` varchar(50) DEFAULT NULL COMMENT '修改用户',
  PRIMARY KEY (`id`),
  KEY `dept_children_fk` (`pid`),
  CONSTRAINT `dept_children_fk` FOREIGN KEY (`pid`) REFERENCES `fast_base_dept` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='部门管理表';

-- ----------------------------
--  Records of `fast_base_dept`
-- ----------------------------
BEGIN;
INSERT INTO `fast_base_dept` VALUES ('3', null, '4', '0001', '综合管理部', '管理部', '综合性', null, '', '', '', '', '', '1', null, null, null, null, null, null), ('4', '3', '4', '0001-2', '人力资源部', '', '', null, '', '', '', '', '', '1', null, null, null, null, null, null), ('5', '3', '4', '0001-1', '信息技术部', '', '', null, '', '', '', '', '', '2', null, null, null, null, null, null), ('6', '3', '4', '0001-3', '财务部', '', '', null, '', '', '', '', '', '3', null, null, null, null, null, null), ('7', '3', '4', '0001-4', '行政部', '', '', null, '', '', '', '', '', '4', null, null, null, null, null, null), ('8', '3', '4', '0001-5', '采购部', '', '', null, '', '', '', '', '', '5', null, null, null, null, null, null), ('9', null, '4', '0002', '工程部', '', '', null, '', '', '', '', '', '1', null, null, null, null, null, null), ('10', '9', '4', '0002-1', '品质部', '', '', null, '', '', '', '', '', '1', null, null, null, null, null, null), ('11', '9', '4', '0002-2', '市场部', '', '', null, '', '', '', '', '', '2', null, null, null, null, null, null), ('12', '9', '4', '0002-3', '企划部', '', '', null, '', '', '', '', '', '3', null, null, null, null, null, null), ('13', null, '5', '0010', '生产部', '', '', null, '', '', '', '', '', '1', null, null, null, null, null, null), ('14', '13', '5', '0010-1', '培训部', '', '', null, '', '', '', '', '', null, null, null, null, null, null, null), ('15', '13', '5', '0010-2', '媒体部', '', '', null, '', '', '', '', '', '2', null, null, null, null, null, null), ('16', null, '5', '0020', '业务部', '', '', null, '', '', '', '', '', '1', null, null, null, null, null, null), ('17', '16', '5', '0020-1', '仓储部', '', '', null, '', '', '', '', '', '1', null, null, null, null, null, null);
COMMIT;

-- ----------------------------
--  Table structure for `fast_base_dept_role`
-- ----------------------------
DROP TABLE IF EXISTS `fast_base_dept_role`;
CREATE TABLE `fast_base_dept_role` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `group_id` bigint(20) DEFAULT NULL COMMENT '群组主键',
  `role_id` bigint(20) DEFAULT NULL COMMENT '角色主键',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='群组关了角色表';

-- ----------------------------
--  Table structure for `fast_base_employee`
-- ----------------------------
DROP TABLE IF EXISTS `fast_base_employee`;
CREATE TABLE `fast_base_employee` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '职员主键',
  `user_id` bigint(20) NOT NULL COMMENT '用户主键',
  `cpmpany_id` bigint(20) NOT NULL COMMENT '公司主键',
  `dept_id` bigint(20) NOT NULL COMMENT '部门主键',
  `post_id` bigint(20) NOT NULL COMMENT '岗位主键',
  `photograph` varchar(50) DEFAULT NULL COMMENT '照片',
  `idCard` varchar(50) DEFAULT NULL COMMENT '身份证',
  `age` int(11) DEFAULT NULL COMMENT '年龄',
  `bankCode` varchar(100) DEFAULT NULL COMMENT '工资卡',
  `officePhone` varchar(100) DEFAULT NULL COMMENT '办公电话',
  `officeAddress` varchar(100) DEFAULT NULL COMMENT '办公地址',
  `officeFax` varchar(100) DEFAULT NULL COMMENT '办公传真',
  `education` varchar(50) DEFAULT NULL COMMENT '最高学历',
  `school` varchar(50) DEFAULT NULL COMMENT '毕业院校',
  `graduationDate` datetime DEFAULT NULL COMMENT '毕业时间',
  `major` varchar(50) DEFAULT NULL COMMENT '所学专业',
  `degree` varchar(200) DEFAULT NULL COMMENT '最高学位',
  `workingDate` datetime DEFAULT NULL COMMENT '工作时间',
  `homeZipCode` varchar(100) DEFAULT NULL COMMENT '家庭住址邮编',
  `homeAddress` varchar(100) DEFAULT NULL COMMENT '家庭住址',
  `homePhone` varchar(100) DEFAULT NULL COMMENT '住宅电话',
  `province` varchar(100) DEFAULT NULL COMMENT '籍贯省',
  `city` varchar(100) DEFAULT NULL COMMENT '籍贯市',
  `area` varchar(100) DEFAULT NULL COMMENT '籍贯区',
  `nativePlace` varchar(100) DEFAULT NULL COMMENT '籍贯',
  `party` varchar(100) DEFAULT NULL COMMENT '政治面貌',
  `nation` varchar(100) DEFAULT NULL COMMENT '国籍',
  `nationality` varchar(100) DEFAULT NULL COMMENT '民族',
  `duty` varchar(100) DEFAULT NULL COMMENT '职务',
  `workingProperty` varchar(100) DEFAULT NULL COMMENT '用工性质',
  `competency` varchar(100) DEFAULT NULL COMMENT '职业资格',
  `emergencyContact` varchar(100) DEFAULT NULL COMMENT '紧急联系',
  `isDimission` varchar(200) DEFAULT NULL COMMENT '离职',
  `dimissionDate` datetime DEFAULT NULL COMMENT '离职日期',
  `dimissionCause` varchar(200) DEFAULT NULL COMMENT '离职原因',
  `dimissionWhither` varchar(200) DEFAULT NULL COMMENT '离职去向',
  `remark` longtext COMMENT '备注',
  `createTime` datetime DEFAULT NULL COMMENT '创建时间',
  `createUserId` bigint(20) DEFAULT NULL COMMENT '创建用户主键',
  `createUserName` varchar(50) DEFAULT NULL COMMENT '创建用户',
  `modifyTime` datetime DEFAULT NULL COMMENT '修改时间',
  `modifyUserId` bigint(20) DEFAULT NULL COMMENT '修改用户主键',
  `modifyUserName` varchar(50) DEFAULT NULL COMMENT '修改用户',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='职员管理';

-- ----------------------------
--  Table structure for `fast_base_group`
-- ----------------------------
DROP TABLE IF EXISTS `fast_base_group`;
CREATE TABLE `fast_base_group` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '群组主键',
  `companyId` bigint(20) DEFAULT NULL COMMENT '公司主键',
  `deptId` bigint(20) DEFAULT NULL COMMENT '部门主键',
  `category` varchar(50) DEFAULT NULL COMMENT '角色分类（研发，调研...）',
  `code` varchar(50) DEFAULT NULL COMMENT '编码（唯一编码）',
  `fullName` varchar(200) DEFAULT NULL COMMENT '名称',
  `remark` varchar(200) DEFAULT NULL COMMENT '备注',
  `sortCode` int(10) DEFAULT '1' COMMENT '排序码',
  `createTime` datetime DEFAULT NULL COMMENT '创建时间',
  `createUserId` bigint(20) DEFAULT NULL COMMENT '创建用户主键',
  `createUserName` varchar(50) DEFAULT NULL COMMENT '创建用户',
  `modifyTime` datetime DEFAULT NULL COMMENT '修改时间',
  `modifyUserId` bigint(20) DEFAULT NULL COMMENT '修改用户主键',
  `modifyUserName` varchar(50) DEFAULT NULL COMMENT '修改用户',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='群组管理表';

-- ----------------------------
--  Records of `fast_base_group`
-- ----------------------------
BEGIN;
INSERT INTO `fast_base_group` VALUES ('1', '4', null, null, 'zz', 'zz', '', '1', null, null, null, null, null, null), ('2', '4', '5', null, 'xx', 'xx', '', '1', null, null, null, null, null, null), ('3', '5', null, null, 'ss', 'ss', '', '1', null, null, null, null, null, null);
COMMIT;

-- ----------------------------
--  Table structure for `fast_base_post`
-- ----------------------------
DROP TABLE IF EXISTS `fast_base_post`;
CREATE TABLE `fast_base_post` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '岗位主键',
  `companyId` bigint(20) DEFAULT NULL COMMENT '公司主键',
  `deptId` bigint(20) DEFAULT NULL COMMENT '部门主键',
  `code` varchar(50) DEFAULT NULL COMMENT '编码（唯一编码）',
  `fullName` varchar(200) DEFAULT NULL COMMENT '名称',
  `remark` varchar(200) DEFAULT NULL COMMENT '备注',
  `sortCode` int(10) DEFAULT '1' COMMENT '排序码',
  `createTime` datetime DEFAULT NULL COMMENT '创建时间',
  `createUserId` bigint(20) DEFAULT NULL COMMENT '创建用户主键',
  `createUserName` varchar(50) DEFAULT NULL COMMENT '创建用户',
  `modifyTime` datetime DEFAULT NULL COMMENT '修改时间',
  `modifyUserId` bigint(20) DEFAULT NULL COMMENT '修改用户主键',
  `modifyUserName` varchar(50) DEFAULT NULL COMMENT '修改用户',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='岗位管理表';

-- ----------------------------
--  Records of `fast_base_post`
-- ----------------------------
BEGIN;
INSERT INTO `fast_base_post` VALUES ('2', '4', null, '11', '11', '', '11', null, null, null, null, null, null), ('3', '4', null, '22', '22', '', '1', null, null, null, null, null, null), ('4', '4', '4', '33', '33', '', '33', null, null, null, null, null, null), ('5', '5', null, '88', '88', '', '1', null, null, null, null, null, null);
COMMIT;

-- ----------------------------
--  Table structure for `fast_base_role`
-- ----------------------------
DROP TABLE IF EXISTS `fast_base_role`;
CREATE TABLE `fast_base_role` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '角色主键',
  `companyId` bigint(20) DEFAULT NULL COMMENT '公司主键',
  `category` varchar(50) DEFAULT NULL COMMENT '角色分类（系统角色，业务角色...）',
  `code` varchar(50) DEFAULT NULL COMMENT '编码（唯一编码）',
  `fullName` varchar(200) DEFAULT NULL COMMENT '名称',
  `remark` varchar(200) DEFAULT NULL COMMENT '备注',
  `sortCode` int(10) DEFAULT '1' COMMENT '排序码',
  `createTime` datetime DEFAULT NULL COMMENT '创建时间',
  `createUserId` bigint(20) DEFAULT NULL COMMENT '创建用户主键',
  `createUserName` varchar(50) DEFAULT NULL COMMENT '创建用户',
  `modifyTime` datetime DEFAULT NULL COMMENT '修改时间',
  `modifyUserId` bigint(20) DEFAULT NULL COMMENT '修改用户主键',
  `modifyUserName` varchar(50) DEFAULT NULL COMMENT '修改用户',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='角色管理表';

-- ----------------------------
--  Records of `fast_base_role`
-- ----------------------------
BEGIN;
INSERT INTO `fast_base_role` VALUES ('1', '4', '系统角色', 'cgzj', '采购总监', '', '1', null, null, null, null, null, null), ('2', '5', '业务角色', 'zjl', '总经理', '', '1', null, null, null, null, null, null), ('3', '4', '系统角色', 'ckbgy', '仓库保管员', '', '1', null, null, null, null, null, null), ('4', '4', '系统角色', 'gcssry', '工程实施人员', '', '1', null, null, null, null, null, null), ('5', '4', '系统角色', 'khfwzg', '客户服务主管', '', '1', null, null, null, null, null, null);
COMMIT;

-- ----------------------------
--  Table structure for `fast_base_role_menu`
-- ----------------------------
DROP TABLE IF EXISTS `fast_base_role_menu`;
CREATE TABLE `fast_base_role_menu` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `role_id` bigint(20) DEFAULT NULL COMMENT '角色主键',
  `menu_id` bigint(20) DEFAULT NULL COMMENT '菜单主键',
  `permit_ids` longtext COMMENT '权限ID集',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=127 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='角色关联菜单表';

-- ----------------------------
--  Records of `fast_base_role_menu`
-- ----------------------------
BEGIN;
INSERT INTO `fast_base_role_menu` VALUES ('38', '3', '37', '6,7'), ('39', '3', '30', '7'), ('40', '2', '26', '6,7,8,9'), ('81', '1', '26', '6,8'), ('82', '1', '37', '6,9'), ('83', '1', '30', '6,7,8,9'), ('84', '1', '32', '6,8,9'), ('117', '5', '26', '6,9'), ('120', '4', '29', '6,7,8,9'), ('121', '4', '26', '6,7,8,9'), ('122', '4', '37', '6,7,8,9'), ('123', '4', '38', '7,8'), ('124', '4', '28', '7,8,9'), ('125', '4', '30', '6,7,8,9'), ('126', '4', '32', '6,8,9');
COMMIT;

-- ----------------------------
--  Table structure for `fast_base_user`
-- ----------------------------
DROP TABLE IF EXISTS `fast_base_user`;
CREATE TABLE `fast_base_user` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '用户主键',
  `company_id` bigint(20) DEFAULT NULL COMMENT '公司主键',
  `dept_id` bigint(20) DEFAULT NULL COMMENT '部门主键',
  `code` varchar(50) DEFAULT NULL COMMENT '用户编码',
  `account` varchar(50) DEFAULT NULL COMMENT '用户账号',
  `password` varchar(100) DEFAULT NULL COMMENT '用户密码',
  `securitySalt` varchar(50) DEFAULT NULL COMMENT '密码秘钥',
  `truename` varchar(50) DEFAULT NULL COMMENT '真实姓名',
  `spell` varchar(200) DEFAULT NULL COMMENT '姓名拼音',
  `gender` varchar(50) DEFAULT NULL COMMENT '性别',
  `birthday` datetime DEFAULT NULL COMMENT '出生日期',
  `mobile` varchar(50) DEFAULT NULL COMMENT '手机',
  `telephone` varchar(50) DEFAULT NULL COMMENT '电话',
  `email` varchar(200) DEFAULT NULL COMMENT '电子邮件',
  `logOnCount` int(11) DEFAULT '0' COMMENT '登录次数',
  `firstVisit` datetime DEFAULT NULL COMMENT '第一次访问时间',
  `previousVisit` datetime DEFAULT NULL COMMENT '上一次访问时间',
  `lastVisit` datetime DEFAULT NULL COMMENT '最后访问时间',
  `remark` varchar(1000) DEFAULT NULL COMMENT '备注',
  `locked` int(11) DEFAULT '1' COMMENT '是否锁定：-1 锁定、 1 正常',
  `iforgot_signature` varchar(200) DEFAULT NULL COMMENT '密码找回的数字签名',
  `iforgot_outDatetime` datetime DEFAULT NULL COMMENT '密码找回，有效期时间（存储的是日期时间）',
  `changePasswordDate` datetime DEFAULT NULL COMMENT '最后修改密码日期',
  `openid` varchar(200) DEFAULT NULL COMMENT '微信的openId',
  `createTime` datetime DEFAULT NULL COMMENT '创建时间',
  `createUserId` bigint(20) DEFAULT NULL COMMENT '创建用户主键',
  `createUserName` varchar(50) DEFAULT NULL COMMENT '创建用户',
  `modifyTime` datetime DEFAULT NULL COMMENT '修改时间',
  `modifyUserId` bigint(20) DEFAULT NULL COMMENT '修改用户主键',
  `modifyUserName` varchar(50) DEFAULT NULL COMMENT '修改用户',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=127 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='用户管理';

-- ----------------------------
--  Records of `fast_base_user`
-- ----------------------------
BEGIN;
INSERT INTO `fast_base_user` VALUES ('96', '4', '8', 'cjgly', 'admin', '62629dbd3d45d471859dd7101135d67a81811b2b61e195744d0c8d143d396ab8', '7a9e6e50b0fcbb8b51273668c8d2095c', '超级管理员', 'chaojiguanliyuan', '男', '2016-02-11 00:00:00', '13143536661', '020-661122', 'yhaoquan@163.com', '62', '2016-02-06 12:23:43', '2016-04-17 17:22:18', '2016-04-17 17:23:57', null, '1', null, null, '2016-04-17 17:22:00', null, null, null, null, null, null, null), ('97', '4', '8', 'zzs', '1039', '602e79657b850f72801cf39e451dbdbec47f7040b4f6389f37ba4368ff2b39bf', 'd0144baff11103c7df2d2801c2b27e1b', '周正松', 'zhouzhengsong', '男', '1993-04-05 00:12:15', '13809627211', '021-01070331', '0107033118@163.com', '12', '2016-02-05 21:42:13', '2016-02-12 20:08:07', '2016-02-14 16:56:20', null, '1', null, null, null, null, null, null, null, null, null, null), ('98', '4', '8', 'zy', '1040', 'ba1989bb631794539badbfb45f93e7a795552e8d5185f20373ac6d09e6567b51', 'bac24adeb00c0849238761dae5424074', '张毅', 'zhangyi', '男', '2007-03-10 00:00:00', '13929155277', '021-03103581', '0310358165@163.com', '0', null, null, null, null, '1', null, null, null, null, null, null, null, null, null, null), ('99', '4', '8', 'ys', '1041', '4a29857d3da12feb108c69b6138026fb724738da59628159e3e51d0be1afb74f', 'e7c3ee0ad504046c4f2773d9109979e6', '阎顺', 'yanshun', '男', '2001-07-07 16:30:15', '13805699025', '021-11386145', '1138614517@163.com', '0', null, null, null, null, '1', null, null, null, null, null, null, null, null, null, null), ('100', '4', '8', 'pj', '1042', 'fe771dcdaf5579c334c241210033d3f7ee21f638a078611a029c3baaab76ba91', 'a9903c484604be222be6682f8af7ec59', '潘杰', 'panjie', '男', '1988-04-21 08:25:17', '13621877511', '021-81570208', '8157020830@tom.com', '0', null, null, null, null, '1', null, null, null, null, null, null, null, null, null, null), ('101', '4', '8', 'xh', '1043', '762f3f3343cd58747584e24a575f0583e309b87efa730a505f31925983e2fbd1', '938397a5165439f6a3ff9d4e5da7cfc9', '许洪', 'xuhong', '男', '1996-03-13 19:39:05', '15162636627', '021-34537356', '3453735653@qq.com', '0', null, null, null, null, '1', null, null, null, null, null, null, null, null, null, null), ('102', '4', '8', 'zy', '1044', '63233157abb75b7c4f09df5ce2127ee74854042ace1cb81bd13bde44fe0aed9e', 'ee67ff8c891ecf395ee54dc3a25ad109', '赵炎', 'zhaoyan', '男', '2000-05-25 05:12:58', '13818143187', '021-77878758', '7787875825@126.com', '2', '2016-02-05 21:41:25', '2016-02-05 21:41:25', '2016-02-05 21:41:58', null, '1', null, null, null, null, null, null, null, null, null, null), ('103', '4', '8', 'hj', '1045', 'cc24ce212fc0a55c524a41305a590e8ad433568080bf6c90a63f4317d740cf0b', '6b34d9ee963c5bf136edc153b25e3bed', '胡静', 'hujing', '男', '1988-02-07 02:18:00', '13867168168', '021-54803627', '5480362718@126.com', '0', null, null, null, null, '1', null, null, null, null, null, null, null, null, null, null), ('104', '4', '8', 'lfq', '1046', 'cbd2ccb9edd58a89d70cc1b53692f427ecd714a96dbaa5da5ae004ee3afe32d5', 'cc5064d01b5c1b92c5dd8a24be67963e', '赖凤琪', 'laifengqi', '女', '2004-03-19 00:52:02', '13820516908', '021-61652468', '6165246872@126.com', '0', null, null, null, null, '1', null, null, null, null, null, null, null, null, null, null), ('105', '4', '8', 'sf', '1047', '357f83b068f6cfcd132ba2944d92324e3c72221de43acb23249f280720b4b5a7', '2cdd9f280e2bd4dc4c01a2733ab80d64', '史菲', 'shifei', '男', '2015-06-04 04:19:52', '13585797207', '021-04557640', '0455764071@163.com', '0', null, null, null, null, '1', null, null, null, null, null, null, null, null, null, null), ('106', '4', '8', 'gf', '1048', '60c5a261d00d7e28a8dbfbe6d39213947d7b6829020e2646d5a23a99183d5748', '248a9a518aadb96082ba3249c58b8c89', '高菲', 'gaofei', '女', '2011-09-12 06:43:33', '13967835866', '021-68558227', '6855822737@126.com', '0', null, null, null, null, '1', null, null, null, null, null, null, null, null, null, null), ('107', '4', '8', 'zy', '1049', 'ed270cd036f34a17c302d54a49c1991f6e7f04e24cb138b5583353a60445baf6', 'e6bdc1175dc0ce285f38ca5f89b475df', '张烨', 'zhangye', '女', '1991-09-30 13:53:04', '18623555060', '021-22033863', '2203386308@qq.com', '0', null, null, null, null, '1', null, null, null, null, null, null, null, null, null, null), ('108', '4', '8', 'zjc', '1050', '43163d8b8777e918dceb4521030869f7fed647ea1470a4f94f720afd14c54f6e', 'ee05feb6ab022e890db4025cda0ea52c', '张静春', 'zhangjingchun', '男', '2005-10-30 11:23:16', '13918150910', '021-28132444', '2813244462@qq.com', '0', null, null, null, null, '1', null, null, null, null, null, null, null, null, null, null), ('109', '4', '8', 'jgy', '1051', '377cd28f82f5afca4d27bf0724b49adcf89b1c8d2eae31a2b33b816cd541a322', '0dd231c815abe7ac6ddabb80677cc6f7', '纪国蔚', 'jiguoyu', '男', '2001-08-03 03:49:30', '13917770824', '021-28748001', '2874800122@qq.com', '0', null, null, null, null, '1', null, null, null, null, null, null, null, null, null, null), ('110', '4', '8', 'zl', '1052', '9b05909bc32efc2eda9005d335a04ce59229cb3be5498ed292af172a1fdcf5e5', '54f0dc100987733d181ae3ca1fafa718', '左林', 'zuolin', '女', '1994-07-15 09:30:57', '13455233606', '021-80847168', '8084716843@tom.com', '0', null, null, null, null, '1', null, null, null, null, null, null, null, null, null, null), ('111', '4', '8', 'wrc', '1053', '7adc5f3f4fa58b9670b39a40e74ec4b9f41e7406b2aada4f1e6c58d0e23043ed', '29d330e88acc896e7e1d35dedd1a16b7', '巫瑞琛', 'wuruichen', '男', '1999-07-05 10:20:12', '13882227677', '021-06046540', '0604654026@163.com', '0', null, null, null, null, '1', null, null, null, null, null, null, null, null, null, null), ('112', '4', '8', 'kzl', '1054', '39ee02517a6c68c389d2ff2cd4d1ca1169ef29c7589720f00a6cb7c743612403', '4aa81596b34975b9aa1bd3b83f88ffa6', '康忠录', 'kangzhonglu', '男', '2012-12-10 18:12:29', '13600146698', '021-80260800', '8026080074@tom.com', '0', null, null, null, null, '1', null, null, null, null, null, null, null, null, null, null), ('113', '5', '15', 'lmz', '1055', '6b996067daa054a93a8ff5d7d8c8806e65cfccb5313dd0a063d90555c215d3ef', '131c9242111f5e5ea8164f9d0e30bfca', '吕美昭', 'lvmeizhao', '女', '1998-06-14 16:19:22', '18601218029', '021-86085037', '8608503717@tom.com', '0', null, null, null, null, '1', null, null, null, null, null, null, null, null, null, null), ('114', '5', '15', 'dyj', '1056', '1631e326f86ccc7a42bca7a902763c83211503e317f64804a07099268a402584', '940c95752d03bf547fcbe5ae648c2dbc', '杜悦静', 'duyuejing', '女', '2004-11-17 16:23:50', '15215516511', '021-66837572', '6683757251@126.com', '0', null, null, null, null, '1', null, null, null, null, null, null, null, null, null, null), ('115', '5', '15', 'tsj', '1057', 'c91d4177b96e1b45d2bc110c29df91fa8abd001e3a8e187f85b0f0ac0199ab72', '5f990c40d9e020abae024e247a872edc', '谭诗佳', 'tanshijia', '女', '1998-11-19 14:50:02', '13486585135', '021-73036053', '7303605325@tom.com', '0', null, null, null, null, '1', null, null, null, null, null, null, null, null, null, null), ('116', '5', '15', 'zyy', '1058', '787ae0ca12ecdbb370063409d7761f3738966465a678d850b3f973d17df15b1b', 'fab3b0429a88ebbab2f4fbb7a61afce7', '翟媛媛', 'zhaiyuanyuan', '男', '2011-03-13 18:41:20', '18650816699', '021-01411276', '0141127633@163.com', '0', null, null, null, null, '1', null, null, null, null, null, null, null, null, null, null), ('117', '5', '15', 'wkw', '1059', '8e9273c47680769614105911e712f40f52f5ee9f5607f0d7c96d00e9d5ff428a', '7703e3441233c2c97806a226fa08c05f', '王科娃', 'wangkewa', '男', '1988-09-05 02:23:29', '15895340022', '021-07226314', '0722631466@163.com', '0', null, null, null, null, '1', null, null, null, null, null, null, null, null, null, null), ('118', '5', '15', 'wjj', '1060', '554e14e3a74baff0dcede4cc54c8911010a445cf938174c93c655b0c3c5e1a25', '1e03f8c5d08237d3ffdf6d469a210b0d', '王景景', 'wangjingjing', '男', '1991-09-15 05:45:00', '13761601760', '021-14325805', '1432580531@163.com', '0', null, null, null, null, '1', null, null, null, null, null, null, null, null, null, null), ('119', '5', '15', 'zqf', '1061', '4b1142138ad93c9eb425194077382717bd16cb2fe9770b9a2ba9619b2d6045e8', 'd7de486fc8adc4b8219118cc566f5cdf', '周庆芬', 'zhouqingfen', '男', '2003-07-20 22:49:21', '18612559991', '021-11424376', '1142437614@qq.com', '0', null, null, null, null, '1', null, null, null, null, null, null, null, null, null, null), ('120', '5', '15', 'hy', '1062', '3073829855c56a6d66aff4a81eda2533287b35bd912f96f5dd6e76211219df6c', '7f44e195917a18db54a033849995de98', '韩烨', 'hanye', '女', '1992-06-09 06:41:07', '13764192193', '021-48373843', '4837384363@21cn.com', '0', null, null, null, null, '1', null, null, null, null, null, null, null, null, null, null), ('121', '5', '15', 'ldr', '1063', 'f64c0b15021e7a9f0f25fb9eaf6e53558d3725ec7a2851c5580ad21232b0c346', '5ba7f360c361f4c968f0c0b1be77f7f9', '李丹若', 'lidanruo', '男', '2015-07-08 16:22:47', '13958577899', '021-46610610', '4661061024@21cn.com', '0', null, null, null, null, '1', null, null, null, null, null, null, null, null, null, null), ('122', '5', '15', 'xl', '1064', 'dcd66773cf6c6b1f091eb983058d8479e6315ec5f60a5b46e8ae08f1ca6c2abf', '94e57a916dbbe39d375d7d91f2692996', '徐力', 'xuli', '男', '2014-04-18 19:03:37', '15026699875', '021-70041212', '7004121287@tom.com', '0', null, null, null, null, '1', null, null, null, null, null, null, null, null, null, null), ('123', '5', '15', 'zwd', '1065', 'abaa98662759d995f75e4633050fd66ae7916419a579cea2bcd869403b20ba99', 'cd9fad08a67bfd08e235c7eaf0e815fb', '张文迪', 'zhangwendi', '男', '1992-01-13 01:19:04', '18859577999', '021-06753102', '0675310267@163.com', '0', null, null, null, null, '1', null, null, null, null, null, null, null, null, null, null), ('124', '5', '15', 'lf', '1066', '60d4a190bf31fb45f7a460d4ff57c4a2cf6170fbb098b3c479d15531a74a4042', 'e5bf9c8956dede68444e528caccc8d2a', '刘峰', 'liufeng', '男', '2000-10-26 22:50:08', '13524055239', '021-40184583', '4018458330@21cn.com', '0', null, null, null, null, '1', null, null, null, null, null, null, null, null, null, null), ('125', '5', '15', 'yyz', '1067', 'd897afc3a530cc1bb30e356ab6589364aaf5c8764ab68d3b14224a3f012da449', 'd62dda1d9947e009f7fe56146aaf17df', '杨永志', 'yangyongzhi', '男', '2009-03-17 20:03:24', '15801963947', '021-72818144', '7281814416@tom.com', '0', null, null, null, null, '1', null, null, null, null, null, null, null, null, null, null), ('126', '5', '15', 'qhl', '1068', '337d73947730bfe16a0d190f488fb63509d712db9c942c57ce9b9cab76ab8c3f', '7a9a7b777cf822efe3d5d78950134be1', '曲宏蕾', 'quhonglei', '男', '2014-03-08 13:28:36', '15850598889', '021-36631224', '3663122483@21cn.com', '0', null, null, null, null, '1', null, null, null, null, null, null, null, null, null, null);
COMMIT;

-- ----------------------------
--  Table structure for `fast_base_user_role`
-- ----------------------------
DROP TABLE IF EXISTS `fast_base_user_role`;
CREATE TABLE `fast_base_user_role` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `user_id` bigint(20) DEFAULT NULL COMMENT '用户主键',
  `role_id` bigint(20) DEFAULT NULL COMMENT '角色主键',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='用户关了角色表';

-- ----------------------------
--  Records of `fast_base_user_role`
-- ----------------------------
BEGIN;
INSERT INTO `fast_base_user_role` VALUES ('2', '97', '4'), ('5', '100', '4'), ('7', '102', '4'), ('8', '103', '4'), ('9', '104', '4'), ('10', '105', '4'), ('11', '106', '4'), ('12', '107', '4'), ('13', '108', '4'), ('14', '109', '4'), ('15', '110', '4'), ('16', '111', '4'), ('17', '112', '4'), ('20', '99', '3'), ('21', '99', '1'), ('22', '101', '3'), ('23', '101', '1'), ('24', '113', '2'), ('25', '98', '1'), ('26', '98', '3'), ('27', '98', '4'), ('28', '98', '5'), ('34', '96', '5'), ('35', '96', '4');
COMMIT;

-- ----------------------------
--  Table structure for `fast_system_datadict`
-- ----------------------------
DROP TABLE IF EXISTS `fast_system_datadict`;
CREATE TABLE `fast_system_datadict` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '字典主键',
  `pid` bigint(20) DEFAULT NULL COMMENT '父级主键',
  `code` varchar(50) DEFAULT NULL COMMENT '编码（唯一编码）',
  `category` varchar(50) DEFAULT NULL COMMENT '分类（catalog 字典目录、 project 字典项目）',
  `fullName` varchar(200) DEFAULT NULL COMMENT '名称',
  `sortCode` int(10) DEFAULT '1' COMMENT '排序码',
  `isTree` bit(1) DEFAULT NULL COMMENT '字典项目的值是否为树状',
  `remark` varchar(200) DEFAULT NULL COMMENT '备注',
  `createTime` datetime DEFAULT NULL COMMENT '创建时间',
  `createUserId` bigint(20) DEFAULT NULL COMMENT '创建用户主键',
  `createUserName` varchar(50) DEFAULT NULL COMMENT '创建用户',
  `modifyTime` datetime DEFAULT NULL COMMENT '修改时间',
  `modifyUserId` bigint(20) DEFAULT NULL COMMENT '修改用户主键',
  `modifyUserName` varchar(50) DEFAULT NULL COMMENT '修改用户',
  PRIMARY KEY (`id`),
  KEY `fast_system_datadict_children_fk` (`pid`),
  CONSTRAINT `fast_system_datadict_children_fk` FOREIGN KEY (`pid`) REFERENCES `fast_system_datadict` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='数据字典';

-- ----------------------------
--  Records of `fast_system_datadict`
-- ----------------------------
BEGIN;
INSERT INTO `fast_system_datadict` VALUES ('22', null, 'aa', 'catalog', 'aa', '1', b'0', null, null, null, null, null, null, null), ('23', '22', 'bb', 'project', 'bb', '1', b'0', null, null, null, null, null, null, null), ('24', '22', 'cc', 'project', 'cc', '2', b'0', null, null, null, null, null, null, null);
COMMIT;

-- ----------------------------
--  Table structure for `fast_system_datadict_detail`
-- ----------------------------
DROP TABLE IF EXISTS `fast_system_datadict_detail`;
CREATE TABLE `fast_system_datadict_detail` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '字典明细主键',
  `pid` bigint(20) DEFAULT NULL COMMENT '父级主键',
  `data_dict_id` bigint(20) DEFAULT NULL COMMENT '数据字典主键',
  `code` varchar(50) DEFAULT NULL COMMENT '编码（唯一编码）',
  `dictName` varchar(200) DEFAULT NULL COMMENT '项目名称',
  `dictValue` varchar(200) DEFAULT NULL COMMENT '项目值',
  `remark` varchar(200) DEFAULT NULL COMMENT '备注',
  `sortCode` int(10) DEFAULT '1' COMMENT '排序码',
  `createTime` datetime DEFAULT NULL COMMENT '创建时间',
  `createUserId` bigint(20) DEFAULT NULL COMMENT '创建用户主键',
  `createUserName` varchar(50) DEFAULT NULL COMMENT '创建用户',
  `modifyTime` datetime DEFAULT NULL COMMENT '修改时间',
  `modifyUserId` bigint(20) DEFAULT NULL COMMENT '修改用户主键',
  `modifyUserName` varchar(50) DEFAULT NULL COMMENT '修改用户',
  PRIMARY KEY (`id`),
  KEY `fast_system_datadict_detail_children_fk` (`pid`),
  KEY `fast_system_datadict_detail_fk` (`data_dict_id`),
  CONSTRAINT `fast_system_datadict_detail_children_fk` FOREIGN KEY (`pid`) REFERENCES `fast_system_datadict_detail` (`id`),
  CONSTRAINT `fast_system_datadict_detail_fk` FOREIGN KEY (`data_dict_id`) REFERENCES `fast_system_datadict` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='数据字典明细';

-- ----------------------------
--  Records of `fast_system_datadict_detail`
-- ----------------------------
BEGIN;
INSERT INTO `fast_system_datadict_detail` VALUES ('18', null, '23', '11', '综合性', '11', null, '1', null, null, null, null, null, null), ('19', null, '23', '22', '22', '22', null, '1', null, null, null, null, null, null), ('20', null, '23', '33', '33', '33', null, '1', null, null, null, null, null, null), ('21', null, '24', 'c1', 'c1', 'c1', null, '1', null, null, null, null, null, null), ('22', null, '24', 'c2', 'c2', 'c2', null, '1', null, null, null, null, null, null);
COMMIT;

-- ----------------------------
--  Table structure for `fast_system_menu`
-- ----------------------------
DROP TABLE IF EXISTS `fast_system_menu`;
CREATE TABLE `fast_system_menu` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '菜单主键',
  `pid` bigint(20) DEFAULT NULL COMMENT '父级主键',
  `category` varchar(50) DEFAULT NULL COMMENT '分类（catalog、page）',
  `code` varchar(50) DEFAULT NULL COMMENT '编码（唯一编码）',
  `fullName` varchar(200) DEFAULT NULL COMMENT '名称',
  `location` varchar(200) DEFAULT NULL COMMENT '访问地址',
  `iconCls` varchar(100) DEFAULT NULL COMMENT 'Easyui图标或图标字体库',
  `target` varchar(50) DEFAULT NULL COMMENT '资源地址',
  `level` int(10) DEFAULT NULL COMMENT '级别层次',
  `isexpand` int(10) DEFAULT '1' COMMENT '展开：-1 折叠、 1 展开',
  `enabled` int(10) DEFAULT '1' COMMENT '有效：-1 有效、 1 无效',
  `defaultSelect` bit(1) DEFAULT NULL COMMENT '默认选中',
  `sortCode` int(10) DEFAULT '1' COMMENT '排序码',
  `remark` varchar(200) DEFAULT NULL COMMENT '备注',
  `createTime` datetime DEFAULT NULL COMMENT '创建时间',
  `createUserId` bigint(20) DEFAULT NULL COMMENT '创建用户主键',
  `createUserName` varchar(50) DEFAULT NULL COMMENT '创建用户',
  `modifyTime` datetime DEFAULT NULL COMMENT '修改时间',
  `modifyUserId` bigint(20) DEFAULT NULL COMMENT '修改用户主键',
  `modifyUserName` varchar(50) DEFAULT NULL COMMENT '修改用户',
  PRIMARY KEY (`id`),
  KEY `menu_children_fk` (`pid`),
  CONSTRAINT `menu_children_fk` FOREIGN KEY (`pid`) REFERENCES `fast_system_menu` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='模块菜单表';

-- ----------------------------
--  Records of `fast_system_menu`
-- ----------------------------
BEGIN;
INSERT INTO `fast_system_menu` VALUES ('25', null, 'catalog', 'system_manager', '系统管理', '', 'fa-bank', 'iframe', null, '1', '1', b'0', '1', null, null, null, null, null, null, null), ('26', '25', 'page', 'menu', '菜单管理', '/manager/system/menu/main', '', 'iframe', null, '1', '1', b'0', '1', null, null, null, null, null, null, null), ('27', null, 'catalog', 'base', '基础资料', '', 'fa-gears', 'click', null, '1', '1', b'0', '1', null, null, null, null, null, null, null), ('28', '27', 'page', 'company', '公司管理', '/manager/base/company/main', '', 'iframe', null, '1', '1', b'0', '1', null, null, null, null, null, null, null), ('29', '27', 'page', 'dept', '部门管理', '/manager/base/dept/main', '', 'iframe', null, '1', '1', b'0', '2', null, null, null, null, null, null, null), ('30', '27', 'page', 'role', '角色管理', '/manager/base/role/main', '', 'iframe', null, '1', '1', b'0', '3', null, null, null, null, null, null, null), ('31', '27', 'page', 'gangwei', '岗位管理', '/manager/base/post/main', '', 'iframe', null, '1', '1', b'0', '4', null, null, null, null, null, null, null), ('32', '27', 'page', 'usergroup', '群组管理', '/manager/base/group/main', '', 'iframe', null, '1', '1', b'0', '5', null, null, null, null, null, null, null), ('33', '27', 'page', 'user', '用户管理', '/manager/base/user/main', '', 'iframe', null, '1', '1', b'0', '6', null, null, null, null, null, null, null), ('34', null, 'catalog', 'test', '第三方控件整合', '', 'fa-graduation-cap', 'click', null, '1', '1', b'0', '1', null, null, null, null, null, null, null), ('35', '34', 'page', 'FontAwesome', '奥森图标', '/manager/other/ui_icons', '', 'iframe', null, '1', '1', b'0', '1', null, null, null, null, null, null, null), ('36', '34', 'page', 'baidu-ueditor', '百度在线编辑器', '/manager/other/ueditor', '', 'iframe', null, '1', '1', b'0', '2', null, null, null, null, null, null, null), ('37', '25', 'page', 'DataDict', '数据字典', '/manager/system/datadict/main', '', 'iframe', null, '1', '1', b'0', '2', null, null, null, null, null, null, null), ('38', '25', 'page', 'permit', '权限管理', '/manager/system/permit/main', '', 'iframe', null, '1', '1', b'0', '3', null, null, null, null, null, null, null);
COMMIT;

-- ----------------------------
--  Table structure for `fast_system_menu_permit`
-- ----------------------------
DROP TABLE IF EXISTS `fast_system_menu_permit`;
CREATE TABLE `fast_system_menu_permit` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `menu_id` bigint(20) DEFAULT NULL COMMENT '菜单主键',
  `permit_id` bigint(20) DEFAULT NULL COMMENT '权限主键',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='菜单关联权限表';

-- ----------------------------
--  Records of `fast_system_menu_permit`
-- ----------------------------
BEGIN;
INSERT INTO `fast_system_menu_permit` VALUES ('11', '26', '6'), ('12', '26', '7'), ('13', '26', '8'), ('14', '26', '9'), ('15', '37', '6'), ('16', '37', '7'), ('17', '37', '8'), ('18', '37', '9'), ('19', '38', '7'), ('20', '38', '8'), ('21', '29', '6'), ('22', '29', '7'), ('23', '29', '8'), ('24', '29', '9'), ('25', '30', '6'), ('26', '30', '7'), ('27', '30', '8'), ('28', '30', '9'), ('29', '32', '6'), ('30', '32', '8'), ('31', '32', '9'), ('32', '28', '7'), ('33', '28', '8'), ('34', '28', '9');
COMMIT;

-- ----------------------------
--  Table structure for `fast_system_permit`
-- ----------------------------
DROP TABLE IF EXISTS `fast_system_permit`;
CREATE TABLE `fast_system_permit` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '权限主键',
  `category` varchar(50) DEFAULT NULL COMMENT '分类',
  `fullName` varchar(200) DEFAULT NULL COMMENT '名称',
  `identity` varchar(200) DEFAULT NULL COMMENT '权限标识',
  `sortCode` int(10) DEFAULT '1' COMMENT '排序码',
  `remark` varchar(200) DEFAULT NULL COMMENT '备注',
  `createTime` datetime DEFAULT NULL COMMENT '创建时间',
  `createUserId` bigint(20) DEFAULT NULL COMMENT '创建用户主键',
  `createUserName` varchar(50) DEFAULT NULL COMMENT '创建用户',
  `modifyTime` datetime DEFAULT NULL COMMENT '修改时间',
  `modifyUserId` bigint(20) DEFAULT NULL COMMENT '修改用户主键',
  `modifyUserName` varchar(50) DEFAULT NULL COMMENT '修改用户',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='权限表';

-- ----------------------------
--  Records of `fast_system_permit`
-- ----------------------------
BEGIN;
INSERT INTO `fast_system_permit` VALUES ('6', null, '添加', 'add', '1', '', null, null, null, null, null, null), ('7', null, '删除', 'delete', '1', '', null, null, null, null, null, null), ('8', null, '修改', 'update', '1', '', null, null, null, null, null, null), ('9', null, '查询', 'read', '1', '', null, null, null, null, null, null);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
